need example sql transaction procedures for sales tracking or financial database [closed]

Posted by fa1c0n3r on Programmers See other posts from Programmers or by fa1c0n3r
Published on 2011-02-12T03:02:16Z Indexed on 2011/02/12 7:32 UTC
Read the original article Hit count: 285

Filed under:

sql

|

financial

|

Sales

|

stored-procedures

hi, i am making a database for an accounting/sales type system similar to a car sales database and would like to make some transactions for the following real world actions

salesman creates new product shipped onto floor (itempk, car make, year, price). salesman changes price. salesman creates sale entry for product sold (salespk, itemforeignkey, price sold, salesman). salesman cancels item for removed product. salesman cancels sale for cancelled sale the examples i have found online are too generic...like this is a transaction... i would like something resembling what i am trying to do to understand it.

anybody have some good similar or related sql examples i can look at to design these? do people use transactions for sales databases? or if you have done this kind of sql transaction before could you make an outline for how these could be made? thanks

my thread so far on stack overflow... http://stackoverflow.com/q/4975484/613799

© Programmers or respective owner

Related posts about sql

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
SQL SERVER – Concat Function in SQL Server – SQL Concatenation

as seen on SQL Authority - Search for 'SQL Authority'
Earlier this week, I was delivering Advanced BI training on the subject of “SQL Server 2008 R2″. I had great time delivering the session. During the session, we talked about SQL Server 2010 Denali. Suddenly one of the attendees suggested his displeasure for the product. He said, even though… >>> More
Error with SQL Server Setup 2012 on Windows 2012

as seen on Server Fault - Search for 'Server Fault'
I am trying to install SQL Server on Windows 2012. I was able to finally get the wizard up and running after making some changes on the server, but now it fails no matter what I do with the following error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: … >>> More
How can I detect which version of SQL (eg SQL 2008 or SQL Azure)

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to detect which version of SQL I am dealing with to perorm various tasks, I need specifically detect if I am on SQL 2008 or SQL Azure. How can I do this with detection code written in SQL? >>> More
Nested SQL Select statement fails on SQL Server 2000, ok on SQL Server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is the query: INSERT INTO @TempTable SELECT UserID, Name, Address1 = (SELECT TOP 1 [Address] FROM (SELECT TOP 1 [Address] FROM [UserAddress] ua INNER JOIN UserAddressOrder uo ON ua.UserID = uo.UserID WHERE ua.UserID = u.UserID ORDER BY uo.AddressOrder ASC) q ORDER BY AddressOrder… >>> More

Related posts about financial

Choosing the Right Financial Consolidation and Reporting Solution

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Financial reporting requirements for publicly-held companies are changing and getting more complex. With the upcoming convergence of US GAAP and IFRS, demand for more detailed non-financial disclosures, and the SEC mandate for XBRL financial executives are under pressure to ensure they have the right… >>> More
Statistical and Financial Considerations in Website Optimization

as seen on Internet.com - Search for 'Internet.com'
Have you tried several different methods to drive traffic to your sites with limited or no success? Well today Marcia Gulesian is to show us this emerging approach that uses statistics and user input to help you achieve your goal. >>> More
Database Security Lacking at Financial Services Firms

as seen on Internet.com - Search for 'Internet.com'
New research from the Ponemon Institute and Compuware details sloppy data practices that pervade the financial services sector and outlines the potential consequences of a breach. >>> More
Financial Services Firms Ripe for Data Attacks

as seen on Internet.com - Search for 'Internet.com'
Ponemon Institute and Compuware study finds porous data protection policies and technologies are putting millions of customersand their assetsat risk. >>> More
What's New in Oracle's PeopleSoft Enterprise Financial Management 9.1

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle's PeopleSoft Enterprise 9.1 is one of the most robust and comprehensive releases in PeopleSoft's history. It includes 21 new solutions, 1,350 new features, more than 28,000 pages enhanced with Web 2.0 capabilities, 300 new Web services and 200 industry-specific enhancements. Specifically… >>> More